UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COL+S9qzC+9pKKYvwhOgl1fm+svZEGGy0djxmpVCd8E='
WHERE
key_id = '12d742913969de8b68cbefc5e4f098d6203b8738b9e99a4e51f6914a1f412854'
AND (
token = 'COL+S9qzC+9pKKYvwhOgl1fm+svZEGGy0djxmpVCd8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)