UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ziVIrpRNkpVhZPL1kXZ2q965d3SfARpt7VkelW3geV4='
WHERE
key_id = '85a788c9900b60c2e0967f66fa4b1219a60cbf4ad239644d672f89665e5e0a30'
AND (
token = 'ziVIrpRNkpVhZPL1kXZ2q965d3SfARpt7VkelW3geV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)