UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9fzX8aW7IV3nzU9VJhBKLR0baWFrFop2NqxTyziyIE='
WHERE
key_id = '87c0ac2dd0f256e69ffa9d6cdc317d5aef34886cd4f7e6e81fe371f1d3b1d39f'
AND (
token = 'L9fzX8aW7IV3nzU9VJhBKLR0baWFrFop2NqxTyziyIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)