UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Caz7pnjMAcq3XyhUL/7VS0xbn6HmJa3Pz7D23VFAN+s='
WHERE
key_id = 'ac584abe846c3f0fd62b384552e5f14d85a5f150538da508b28794648ae4b022'
AND (
token = 'Caz7pnjMAcq3XyhUL/7VS0xbn6HmJa3Pz7D23VFAN+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)