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