UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QDLR1pl06754PkQC2A+bhpoMxjzvhgbTnOZXVqIy0qM='
WHERE
key_id = '7a4c507fbd80c6d501b138ae96a538026cf1193807158cf4085715a57aa9d5d6'
AND (
token = 'QDLR1pl06754PkQC2A+bhpoMxjzvhgbTnOZXVqIy0qM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)