UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z86pHoQMtesuY7hbPrc6fewUTVrYGAHUtAuktRtV4SA='
WHERE
key_id = 'e8c008a70e2cebe5353ecf52ce2ca22da2eb6c49abb716c001a592a29ec3e9ed'
AND (
token = 'Z86pHoQMtesuY7hbPrc6fewUTVrYGAHUtAuktRtV4SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)