UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9NEGrZc+jpVxEr+mANIxk5LuvnLo5xABix2fWBDZ+Q='
WHERE
key_id = 'b544e12362d14c8c34de27be417fed9b3faa42f310d7f831a18b90f2640582a1'
AND (
token = 'h9NEGrZc+jpVxEr+mANIxk5LuvnLo5xABix2fWBDZ+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)