UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sS0ZCBtTT7f916tJUWjZJflYk5jG5srAMcjgMr4ZurY='
WHERE
key_id = '3846e29198e8ae314e3eaf90bf4131d662d9bf0df1c6f8d8b5cb3379b293aaac'
AND (
token = 'sS0ZCBtTT7f916tJUWjZJflYk5jG5srAMcjgMr4ZurY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)