UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q9vMp1HAewgoMR+xb/1BztTA/vGxN764+M/Y/Uk15mM='
WHERE
key_id = '78bae566936255ffefd24a47f22382e8f5b61a00d2c59890f95ab74ee7ed9d10'
AND (
token = 'Q9vMp1HAewgoMR+xb/1BztTA/vGxN764+M/Y/Uk15mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)