UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgwnSpFkHet0YglZMBlLlVJZnP6ciQMx7UxlE0M2kt4='
WHERE
key_id = 'd9a4efc69edf2a7bc8bcbf9dc194a116919de7cf1bcda0190be5ae12d1618d27'
AND (
token = 'lgwnSpFkHet0YglZMBlLlVJZnP6ciQMx7UxlE0M2kt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)