UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F37FdZe5+X/hUQy2wgva6G8GFIz7ZmrlKj6m4HFD4t0='
WHERE
key_id = 'f54f8c20935ce9e3f1e7f290bfe6e31ef1b9d14390defa881c4507b5eea49be4'
AND (
token = 'F37FdZe5+X/hUQy2wgva6G8GFIz7ZmrlKj6m4HFD4t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)