UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'edNG9TVaFPNjoyPHYPmEQwkxIGk11vE8dSA+5l/X92A='
WHERE
key_id = '5bc9237525c86cabb3925ea3b11543f5266aabbbb831342eab6c20ccd02d735a'
AND (
token = 'edNG9TVaFPNjoyPHYPmEQwkxIGk11vE8dSA+5l/X92A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)