UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Kz6/s/HtBvw4esk1FwlpKX9ABURu76A5IF5PVwBYUE='
WHERE
key_id = '3c9b7f0123c3d952f42c47d39048dd4c9812aef1a8aa170204ec2ddd0a9b3892'
AND (
token = '1Kz6/s/HtBvw4esk1FwlpKX9ABURu76A5IF5PVwBYUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)