UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hUvGzIq9guGTaNdgq2BRoR3bVKxb5LbPBOotGFxZGw='
WHERE
key_id = 'dc5bd58efe4a9f52d88a6fbd1c0e2c17ff293546559cc6a205d1201ef4da8da5'
AND (
token = '/hUvGzIq9guGTaNdgq2BRoR3bVKxb5LbPBOotGFxZGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)