UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rrmVdnSgMqGJHVbbcOhsGh2PlJheKJv56D8yH5rsnU='
WHERE
key_id = '31681886967d36fcff987744026b20ac85bf66c06b3067ef7f69e77496595b54'
AND (
token = '1rrmVdnSgMqGJHVbbcOhsGh2PlJheKJv56D8yH5rsnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)