UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPmEqHLQisOjrjVLU4naKPzbS/kX6FaWFi52kEXqql4='
WHERE
key_id = '7f705bbf4ea4829cdc76e2b1ea9b1aff1ba31791ecb5e4ec6d3a78ca86775fed'
AND (
token = 'lPmEqHLQisOjrjVLU4naKPzbS/kX6FaWFi52kEXqql4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)