UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRYPh/wBj8nA7F9/O4MUz1JRGyGLkysOkhUssrOTZo8='
WHERE
key_id = '5dc01b39f4a89529261c042f9b9b389b8ddef4d36fb85eb847132810504dd2a0'
AND (
token = 'BRYPh/wBj8nA7F9/O4MUz1JRGyGLkysOkhUssrOTZo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)