UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJsYzK4Nwf2LzHPnpJue0kHYypW94crSAq+WAfng0sQ='
WHERE
key_id = '0452f3761b997a4401707a19116d65ce70d929098c38485b015b0afa197d8815'
AND (
token = 'zJsYzK4Nwf2LzHPnpJue0kHYypW94crSAq+WAfng0sQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)