UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXMBLUscsH4KMaLlL+fnG9MtWjq8cnqCXGIf57KGcLU='
WHERE
key_id = '0e3b444538d257f595eb178e987138edcb4c02baf63b8fb6b7895247457addf6'
AND (
token = 'oXMBLUscsH4KMaLlL+fnG9MtWjq8cnqCXGIf57KGcLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)