UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TYC5680wT8J/wxtVXBvK/OYkye98NAeSwvpP1t2QjH0='
WHERE
key_id = 'c5fe9b83eff57ec426e85effc4cf5d518f58f1e00ecbb24bbb583968963dabd5'
AND (
token = 'TYC5680wT8J/wxtVXBvK/OYkye98NAeSwvpP1t2QjH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)