UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9+hIP70cAlpPM7JoyvxgTp8isuVmUsOveAbG0pMmYA='
WHERE
key_id = 'cc6f19a55c9eb8804e2cc0b32b1bbe81a23b3890db918fabe4061f96cf3ae919'
AND (
token = 'r9+hIP70cAlpPM7JoyvxgTp8isuVmUsOveAbG0pMmYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)