UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YL6vUiybEjw6qBnt0y3MDwl9om3BMdAsiTLLk5fGM3w='
WHERE
key_id = 'f8bf361901e7930ca05defd89bb69ec59e5ff6c3f7ea38ca6806d72ad709b724'
AND (
token = 'YL6vUiybEjw6qBnt0y3MDwl9om3BMdAsiTLLk5fGM3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)