UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfEo1fQQNXkWFiX5ZE9I0N61d3p0d/b8WBKQYp3xPGQ='
WHERE
key_id = 'b5bb912c00bae44e642d8bf9466e7d6a7cfbd1d9f3a3c8631942fe926206c40e'
AND (
token = 'XfEo1fQQNXkWFiX5ZE9I0N61d3p0d/b8WBKQYp3xPGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)