UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmVWS8cj/XuD4ZiciE0uGeQp4V3XHjJfYakoDHY6RG8='
WHERE
key_id = 'ebabe54d9cab41b2394445a8eefefecf83e9589d6ee473ce00c73ce199817945'
AND (
token = 'tmVWS8cj/XuD4ZiciE0uGeQp4V3XHjJfYakoDHY6RG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)