UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NAFyUBXjph1Y8aFTSao1SrXYN78SLc2HW+uppZujOK4='
WHERE
key_id = 'b443a32636664e65cd259149c742c86b9fc0d54a5db7d36da69e95ae2af9ba0b'
AND (
token = 'NAFyUBXjph1Y8aFTSao1SrXYN78SLc2HW+uppZujOK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)