UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Aeec+wWFp9sJG5CweFJEZzuNEbt3COyy98vX9YbHxc='
WHERE
key_id = 'dd1e3896549eb5dd7f5322c2b907dc9c1e07676f1237775303f3e8ed6719ce3c'
AND (
token = '0Aeec+wWFp9sJG5CweFJEZzuNEbt3COyy98vX9YbHxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)