UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbaE0zxXAZJXu0h3ZtwgS/HxeY/4eRl9mgV2CSXZIx0='
WHERE
key_id = 'c47c66b06a561cc2674976e508d04e6f1dcc9e3fae754aa0624bf81d285cdfb3'
AND (
token = 'bbaE0zxXAZJXu0h3ZtwgS/HxeY/4eRl9mgV2CSXZIx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)