UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+0sM5i6/YqJekn7klo+Muz2K0zdnDujWoT1j5N/+Qr4='
WHERE
key_id = '5a7a4a1e934653aa7635959a18eb9f2e64e73b740b0bf9685d72ccec8d80e14b'
AND (
token = '+0sM5i6/YqJekn7klo+Muz2K0zdnDujWoT1j5N/+Qr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)