UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKQ/CNMfR+mFLwkbx+Yi/9mHMDADuUtaezMYZj7iadE='
WHERE
key_id = 'f07f936ebf4322680660097814286115a3d7ef68430f4dd7ef0923cf0f718244'
AND (
token = 'ZKQ/CNMfR+mFLwkbx+Yi/9mHMDADuUtaezMYZj7iadE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)