UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apTWzp7SOh3dKdHPEBpJvWDpCrGiwN0eBpt26DdmbWc='
WHERE
key_id = '7e29f96bfd20c2f61ba01b99222cd15be31e2ed786140981bae3aa5ecc19eaeb'
AND (
token = 'apTWzp7SOh3dKdHPEBpJvWDpCrGiwN0eBpt26DdmbWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)