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