UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6uOewmYBeIPj26uNE94ao0p113qjTzy1Oabs3AduUHA='
WHERE
key_id = 'acc6c164e5817d27531ce063ea952b26fb400ba7e0825dbc03165b378fe3ecbd'
AND (
token = '6uOewmYBeIPj26uNE94ao0p113qjTzy1Oabs3AduUHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)