UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oB+8rSXp2XQ3143YdW/NAftP/+NI/6kbFyM5YlSJDqw='
WHERE
key_id = '931d8a583391c47c7c4912c843760a57ed89ef390ca7d12a19159ef23a42f9c1'
AND (
token = 'oB+8rSXp2XQ3143YdW/NAftP/+NI/6kbFyM5YlSJDqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)